USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[MapsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.MapsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Maps Table Insert
-- =============================================
CREATE PROCEDURE MapsInsert

            @MapId int,
            @MapShortName varchar(30),
            @MapFullName varchar(50),
            @MapTypeId varchar(50)
	

AS
BEGIN

INSERT INTO [Maps]
           ([MapId]
           ,[MapShortName]
           ,[MapFullName]
           ,[MapTypeId])
     VALUES
           (@MapId,
            @MapShortName,
            @MapFullName,
            @MapTypeId)
END
GO
